/*
 * nlsync
 * Copyright (c) 2010 apechurin 
 * 
 * Permission is hereby granted, free of charge, to any person
 * obtaining a copy of this software and associated documentation
 * files (the "Software"), to deal in the Software without
 * restriction, including without limitation the rights to use,
 * copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the
 * Software is furnished to do so, subject to the following
 * conditions:
 *
 * The above copyright notice and this permission notice shall be
 * included in all copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
 * EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES
 * OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
 * NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT
 * HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,
 * WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
 * FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
 * OTHER DEALINGS IN THE SOFTWARE.
 */
#if DEBUG

using System;
using System.Collections.Generic;
using System.Text;
using NUnit.Framework;
using Excel = Microsoft.Office.Interop.Excel;
#if OLDXLS
using nlsync.XlsOld;
#else
using nlsync.Xls;
#endif
using XlsUtil = nlsync.Xls.XlsUtil;

namespace nlsync.UnitTests.Xls
{
    /// <summary>
    /// Contains some helpers for all tests.
    /// </summary>
    public class XlsTestsHelpers
    {
        /// <summary>
        /// Gets a catalog.
        /// </summary>
        public XlsStringCatalog Catalog
        {
            get
            {
                return XlsTests.Instance.Catalog;
            }
        }

        /// <summary>
        /// Sets the cell value. 
        /// </summary>
        /// <param name="cell">The cell address.</param>
        /// <param name="value">The value.</param>
        public void SetValue(string cell, string value)
        {
            Excel.Range c = Catalog.Worksheet.get_Range(cell, Type.Missing);
            c.Value2 = value;
        }
    }
}

#endif